LOAD DATA
characterset UTF8
APPEND INTO TABLE t_resident_kpi
FIELDS TERMINATED BY ','
trailing nullcols
(
rangetime date "yyyy-mm-dd hh24:mi:ss",
line,
city,
gtusers,
gtvolteusers,
procellnum,
pubcellnum,
protopubnum,
protopronum,
esrvcc bigint
)